Child pages
  • Opening an export file in Excel

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

Using Notepad and finding it difficult to understand the data that's been exported? Then try using Microsoft Excel instead. If you're looking for info on exporting reports to Excel, see Exporting reports.

Import/export files can be opened in Microsoft Excel to view or update the file's contents. Take a look at this video to see how it's done.

HTML
<iframe width="560" height="315" 
src="https://www.youtube.com/embed/K_XKvNNrpTU?rel=0" frameborder="0" 
allowfullscreen></iframe>

You might do this to fix an import file which isn't importing properly, or to bulk update multiple records in your company file.

 

UI Expand
expandedtrue
titleTo open an export file in Excel
  1. Open Microsoft Excel and go to File > Open.
  2. In the Files of type field, select All Files(*.*) and then locate and open the exported text file. The Text Import Wizard appears.
  3. In Step 1 of the Text Import Wizard, select the Delimited option, then click Next.
  4. In Step 2 of the Text Import Wizard, select either the Tab or Comma option (depending on whether you selected to export the data as Tab or Comma separated), then click Next.
  5. In Step 3 of the Text Import Wizard, click Next.
  6. Click Finish. The file contents will be displayed and you can now edit the cells as required.
UI Text Box
sizemedium
typewarning

When you finish editing, close the file and you'll be prompted to save. Click Yes to the message to save it as Text and continue using this format. This will ensure you can import the file back into your MYOB software as the same type of file it was exported as (tab or comma-separated).

save as text file highlighted

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
        

 

      
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Importing and exporting data

Import and export fields

Importing data

Exporting data

Using an import template