Results 1 to 3 of 3

How can I make a cell truly blank when doing a Power Query import from CSV?

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    AZ, USA
    MS-Off Ver
    Office 2016
    Posts
    2

    How can I make a cell truly blank when doing a Power Query import from CSV?

    I am importing data from a CSV file into Excel 2016 using Power Query. Cells that should be blank are not truly blank.

    The columns I am having trouble with are formatted as "Data Type: Text". These columns contain a variety of information and some of the cells are blank. However , when I finalize the import and load the data, these cells are not truly blank.

    For example cell H2 should be blank. If I put a function in I2 "=isblank(H2)" the result is "false". If I click on H2 an press the "DELETE" key, the result turns to "true". Also, If I just double click on H2, the result turns to "true".

    I have a column formatted as "Data Type: Date", which also contains some blank cells. These cells show in the Query Editor preview as "null", and import correctly.

    The blank cells in the source CSV are empty. Meaning it is one comma followed by another comma (,,). There is no space in between, no quotes, and no other characters. This is consistent across the entire CSV.

    I'm sure the solution is simple, I just can't figure it out. Thanks.
    Last edited by Don202020; 12-08-2017 at 03:13 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sub-Forum for Power Query & Power BI?
    By AliGW in forum Suggestions for Improvement
    Replies: 7
    Last Post: 08-26-2018, 05:25 PM
  2. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  3. Power Query, Native Query Paramter
    By Kyle123 in forum Excel General
    Replies: 0
    Last Post: 12-08-2017, 09:29 AM
  4. Import blank cell returns 0,00 - how to import a blank instead?
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2015, 03:12 AM
  5. Power Query Import Binary Data Type
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-13-2015, 09:46 AM
  6. [SOLVED] Power Pivot SQL Data Import - How to update import filter
    By minnesotaart in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2013, 12:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1