How do I make sure all empty columns are present in a .csv file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a .csv file to upload into another program that requires that
all columns be present in the file even if no data is entered. How do I make
sure that each column is recognized on each line of the spreadsheet even if
no data is entered? I do not want to manually have to insert info into a
cell to insure that the upload utility acknowledges it. Thank you.
 
Select the table you're importing, then go to Edit--GoTo--Blanks and enter a
value in all the highlighted blanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Problem with Concatenate - Results are too long for CSV 4
Summing one column based on criteria from two other columns 2
how do I merge multiple csv files in one Excel file? 6
Checkbox - Output results to a csv file 4
How to prevent leading zero's from being dropped from a CSV file 1
.csv to .txt 2

Back
Top