Formatting CSV Files for Import Into NetSuite

CSV formatting for NetSuite

Share this post

Many of us have probably encountered the circumstance when a client or coworker requests that non-formatted data be converted to Netsuite CSV import templates.

These data sets can come from various sources such as .pdf files, websites (HTML) and other formats.

You may have shaken your head in dismay up to this point, unwilling to deal with the complexities of data import types. But don’t worry; I’ve described some pretty simple steps to format the data so that importing the CSV file into NetSuite is a breeze!

I used Notepad++ and Microsoft Excel to complete the task.

Here we go…

 

14 steps for NetSuite CSV Import Process

1. Save the source file as a text (.txt) file

pres 2

2. Open the file with Notepad++

3. Remove the cover page information as that information is not needed

pres 3

4. Choose a CSV delimiter

Make sure your character is not present anywhere in the document and choose a character that is easy to see, for example: *, %, @, &

5. Field mapping

  1. Company Name
  2. Address
  3. Phone
  4. City
  5. Fax
  6. Email
  7. Comment
  • n stands for a new line
  • We will add or update our delimiter at every new line

pres step1

6. Remove “Return/Enter” key entries

  • r stands for the Enter key on the keyboard
  • Replace all the r by “blank” to determine when to break in the next step

 

pres6 step2

7.  Break lines

  • Most entries end after the CR. This will be our breakpoint in this case.
  • The result is the same as if you find all the CR in the file and press Enter on your keyboard manually.

8. Remove headers & footers

  • Check bookmark line
  • Find lines to be deleted
  • Navigate to Search > Bookmark > Remove Bookmarked Lines

pres step4

9. Save text file

This step is essential to setup import export CSV records.

10. Open text file in Excel

  • Data > From Text > Delimited
  • Choose “other” for delimiter and input your character (* in this demo)

pres 7

11. View the result

Notice some columns are off because the company name takes up to two lines in the pdf. This needs to be fixed.

pres 8

12.  Separate Zip code & City

  • The address, city, and zip code entries in Netsuite are divided into different fields. We can use Excel formulas to quickly separate them.
  • You can simply drag the right corner to replicate the same formula for all the entries.

pres 9

13. Remove unused data

Use Find All/Replace all to remove unused data such as “Telephone:”, “Email:”, etc.

step 10

14. Save file as a CSV

And there you have it! The end result that saves time – a beautiful CSV file ready for import into NetSuite!

CSV file to import into NetSuite

erp

Big Bang

Reach us

Discover the Big Bang unbiased consultative approach with expertly trained and well-versed cloud specialists.

fevicon
fevicon
fevicon
fevicon

How does your organization stack up?

Take the Big Bang 360° Business Assessment to uncover opportunities concerning your people, processes, or technology.

Why are you contacting us today?

A Big Bang representative will contact you within 24-hours.

Formatting CSV Files for Import Into NetSuite

Complete the form to download your workbook today.

Become the master of your organization’s business systems – without a headache.

Formatting CSV Files for Import Into NetSuite

Complete the form to download your workbook today.

Become the master of your organization’s business systems – without a headache.

CERTIFICATIONS