How to open a CSV file from BCR in Excel?

  • Start Microsoft Excel and open a new workbook.

  • On the menu bar at the top, click DATA > External

    Sources > From Text.

  • Select your CSV file and click Get Data.

  • Select the Delimited option and click Next.

  • Under Delimiters, check Comma or Semicolon (depending on your region) and click Next.

  • In the Column data format section, select General and click.

  • Now tell the program where you want to put the data and click OK. Your business cards will be displayed in the current spreadsheet.

Important! The delimiter you select in step 5 depends on your region. You can experiment with different delimiters, checking their effect on your data in the Data preview section at the bottom of the Text Import Wizard.




Please sign in to leave a comment.